| |
4965 Search Results Found |
| 1 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:03 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…have two separate sets of issues.
The first is just creating a valid index to begin with.
The second, which requires that the first is already done right, is checking your index rebuild progress and errors.
I will address them separately in two …
|
| 2 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:24 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…following is a simplified demonstration based on your previous post that shows how to check your index creation for errors and how to create a log of the details of the index process from running the index creation statement, then check that log. I …
|
| 3 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…got it working. The auto_filter and the nopopulate are apparently incompatible with the directory_datastore. If those are important and you need some sort of substitute or workaround let me know and I will see what i can figure out.
…
|
| 4 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 16:35 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…removed the Drop index. So now instead of taking 20 minutes to drop the index it is taking 20 minutes to drop the table. In all it still takes 31 minutes to run the script and I am still getting the same error message.
Here is the script…
|
| 5 |
Forum: Forms «»
Posted on: Fri, 12 May 2023 11:51 «»
By: crodrigo
Hide URL call over web_show_document
…URL over PLSQL, by passing the following details
PK_COMMON.pu_set_url ( 'RC',
&…
|
| 6 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 13:37 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is a little better picture of what I am running.
BEGIN
commit;
BEGIN
EXECUTE IMMEDIATE 'DROP INDEX MI.kjc_test_index_url1 FORCE';
&…
|
| 7 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 18:28 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…changed the names, and removed the "parallel 5" and it seemed to have worked. Here is the script that I ran:
commit;
--DROP TABLE KJC_TEST_INDEX_1;
CREATE TABLE KJC_TEST_INDEX_1
&…
|
| 8 |
Forum: Text & interMedia «»
Posted on: Thu, 10 August 2023 23:55 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…should be able to copy and paste the query below and run it.
SELECT TOKEN_TEXT
FROM DR$IMT_MSTR_INDX_URL1$I T
, MASTER_INDEX X
, DR$IMT_MSTR_INDX_URL1$K K
WHERE CONTAINS (X.…
|
| 9 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 13:16 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…you!!
Just for my understanding. Why did I need to do that?
Here is my thinking.
I dropped the table, and thus the index was dropped.
I also dropped the preference: KJC_TEST_INDEX_2_NETWORK_PREF
and then recreated.
I then …
|
| 10 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…think I am getting closer. Here is what I have so far, but it is failing. I am getting a certificate error. How do I resolve that? See error message at bottom.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE …
|
| 11 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is the script that I ran. I had to change a few things in order to get it to run.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE KJC_TEST_INDEX_2
(assigned_id VARCHAR2(11),
…
|
| 12 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:17 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…is my test with network_datastore and timeout of 3600 seconds and no_proxy and 'http://www.example.com/index.html'. The error on the dropping of the url_datastore is only because it had been previously dropped, so that can be ignored.
C##…
|
| 13 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…am past the Cert error and it is indexing the content of the document. However, it is still incomplete. It is only created 203 tokens off of a 58 page document. It is missing several words, and numbers. It is incomplete. That…
|
| 14 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 20:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…did not index the document.
Here is the script that I ran:
DELETE FROM KJC_TEST_INDEX_1 WHERE assigned_id = 'MCP-135'
/
INSERT into KJC_TEST_INDEX_1 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.…
|
| 15 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 19:48 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…I ran the script where you changed the names and removed parallel, I got the same results as you. Hopefully, you left everything intact at that point. Please run the script below. I have posted the output that I got below that. If …
|
| 16 |
Forum: Text & interMedia «»
Posted on: Thu, 10 August 2023 21:20 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…you!!!
Just a little information that I should have given you first time and maybe it doesn't make any difference, but I cannot see how to complete my #1 question above.
The document is not stored in the table, it resides on the file server. &…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 15:04 «»
By: Barbara Boehmer
Re: How to access URL's from your database that are accessible from your browser
…certificate stuff is outside of my area of expertise, but, while you are waiting for Michel or somebody else to reply, perhaps I can shed a little light on things.
From the Firefox browser window, at the top where the url is, to the left of the url, do…
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 10:00 «»
By: kjcook
How to access URL's from your database that are accessible from your browser
…am trying to index the content of a document using NETWORK_DATASTORE in Oracle Text. The URL that I am providing for the document is valid. I have logged on to the DB server, and using FireFox validated the URL. But the content is not being …
|
| 19 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 16:46 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…everything but the index creation statement went well, I would try re-running just the index creation, but without the parallel 5. It looks like it is having a problem with perceiving that there is already an index or it is already locked. It …
|
| 20 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…am running this from TOAD. No, it is not in production.
Here is the output that I am getting:
Commit complete.
Index dropped.
Table dropped.
Table created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed…
|
| 21 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 14:40 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…are right. You need a directory_datastore. I remembered that your files were not stored in your table, but, since you were using a url_datastore, I incorrectly assumed they were on the web. I see now they are in files on your server. &…
|
| 22 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 11:52 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…have modified the script to include this:
BEGIN
CTX_DDL.CREATE_PREFERENCE('KJC_TEST_INDEX_2_NETWORK_PREF','NETWORK_DATASTORE');
CTX_DDL.SET_ATTRIBUTE('KJC_TEST_INDEX_2_NETWORK_PREF','Timeout','3600');
…
|
| 23 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:06 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…looks like the remaining problem may be a timeout issue. You have the timeout parameter of your url_datastore set to 10 seconds. It would be good to increase that. However, apparently url_datastore is deprecated and it just allows a …
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 June 2022 04:36 «»
By: thiyagarajancs
Re: SENDGRID | Curl
…Dears,
I am facing an issue while configuring the email via sendgrid. Kindly help me to resolve the issue.
###########################################Sample Procedure…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 01 March 2024 09:33 «»
By: Duane
Re: BLOB Column with Zip File Convert to CLOB
I can't post them but modeled after https://github.com/antonscheffer/as_zip. I found that package after doing a search.
That should help others looking to do the same thing.
[Edit MC: fix url]
|
| 26 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Thu, 12 October 2023 05:47 «»
By: John Watson
Re: Oracle APEX on tomcat "App Unavailable"
…to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
You need to show what you did and what happened. For example, how did you deploy the ords.war to the webapps directory? Where is your …
|
| 27 |
Forum: Data Integration «»
Posted on: Thu, 28 September 2023 16:09 «»
By: bmccollum
Conditional Execution of Steps in ODI Load Plan
…have an ODI load plan that I'm having difficulty trying to figure out how to continue executing ongoing steps within the load plan *only* if an exit code of 0 is sent from a Unix shell script that's called from the load plan.
If the call to the Unix …
|
| 28 |
Forum: Marketplace «»
Posted on: Wed, 06 September 2023 10:09 «»
By: aidev.uk
Oracle Enterprise Manager plugin testers required
…at AIDEV create management plugins for OEM 13c and are currently seeking companies to test our latest SSL certificate monitoring plugin.
The SSL certificate monitoring plugin gives users the ability to centrally monitor, as OEM 13c targets, application…
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 12:01 «»
By: kjcook
Re: How to access URL's from your database that are accessible from your browser
Didn't I validate that the Certificate was valid or non-existent when I logged into the DB server, and using Firefox was able to browse to the URL with out any errors?
|
| 30 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 15:24 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…you for your help.
The URL is valid and I can get to the documents from my browser. I am in the process of verifying that I can get to them from the database server. I am trying to flush out the certificate error. The documents are …
|
| 31 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 09:03 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…query, ran for 10 minutes and then I finally killed it. Not sure why it takes so long.
But maybe this will help you see what I am trying to solve.
I have a document MCP-135 that i am trying to index its content. The document is not …
|
| 32 |
Forum: Forms «»
Posted on: Thu, 08 June 2023 17:45 «»
By: JonathanXC
Reports in pdf format generated in server but don't open in local machine
…everyone,
I have a report in pdf format created from a form and reports, From the form I execute:
rep_id := Create_ParameterList('tmpdata1');
Add_Parameter(rep_id, 'DESTYPE' , TEXT_PARAMETER, 'CACHE');
Add_Parameter(rep_id, 'PARAMFORM', …
|
| 33 |
Forum: Reports & Discoverer «»
Posted on: Fri, 27 January 2023 00:13 «»
By: Littlefoot
Re: REP-50004: No report is specified on the command line
…means:
REP-50004: No report is specified on the command line.
Cause: There is no report name specified on the command line.
Action: Specify the name of the report on the command line.
Level: 1
Type: ERROR
Now that you posted the whole …
|
| 34 |
Forum: Reports & Discoverer «»
Posted on: Thu, 26 January 2023 00:30 «»
By: Rehan Mirza
Re: REP-50004: No report is specified on the command line
…you for the reply.
Below is the URL.
http://10.40.2.88:9002/reports/rwservlet?server=rep_wls_reports_orcl-forms&userid=IBSOIFC/ja4942Xqs@ORCL&destype=CACHE&de sformat=PDF&desname=D:\OIFC\FMXS\IBSRR015U.PDF¶mform=YES&report…
|
| 35 |
Forum: Reports & Discoverer «»
Posted on: Wed, 25 January 2023 12:57 «»
By: Littlefoot
Re: REP-50004: No report is specified on the command line
Check URL; there's server name, USERID, some other parameters, but - really, no report name (or we don't see it).
server=rep_wls_reports_orcl-forms&userid=IBSOIFC/ja494....&desformat=pdf&destype=cache¶mform=YES&rep
|
| 36 |
Forum: Server Administration «»
Posted on: Tue, 04 October 2022 15:51 «»
By: joy_division
Using OCI storage for BLOBs
…started a new job and they use Oracle Cloud for their databases. They are just implementing putting PDF files into folders in an OCI bucket and having references in a table column to the location via an URL. I am new to the OCI and cloud databases, but it…
|
| 37 |
Forum: Server Administration «»
Posted on: Wed, 24 August 2022 13:37 «»
By: Michel Cadot
Re: Keyword for searching oracle software in MOS.
Oracle downloads are at url https://www.oracle.com/downloads/
|
| 38 |
Forum: Forms «»
Posted on: Sat, 13 August 2022 03:29 «»
By: sasipalarivattom
Re: Files generated on server with sufix
…Hi,
How are you generating the report?
Have you tried generating report in URL
like http://WIN-SERV:9002/reports/rwservlet?server=rep_server1&report=test.rdf&destype=file&desformat=html&userid=scott/ti ger@orcl&desname=c:\rep1.…
|
| 39 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Mon, 28 February 2022 05:45 «»
By: John Watson
Tracing .../r/... calls
…First, please excuse any mistakes I make with terminology or describing things: this is an area beyond my best knowledge.
We have a problem with performance of an application. The pages have many calls for static files, using the /r/ router "…
|
| 40 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 28 January 2002 06:57 «»
By: Ildar
Is it possible somehow to call stored procedures with usage of the SELECT expression ?
…Hi,
I have a requirement in my program to run the SP with SELECT (and get results from it),
example of the procedure-
procedure sp_Session_Create(pi_Protocol IN integer,
pi _SessionId IN OUT integer,
ps_InputParams IN string…
|
Blog
Search
Help
Members
Register
Login
Home